SELECT T.* FROM C1_DICTIONARY T WHERE t.type_code like :typeCode AND t.code like :code
order by t.ORDER_NUM
